-- Script Date: 22/03/2014 18:55  - ErikEJ.SqlCeScripting version 3.5.2.34
CREATE TABLE [INJURIES] (
  [WEEK] tinyint NOT NULL
, [NAME] nvarchar(20) NOT NULL
, [SURNAME] nvarchar(20) NOT NULL
, [POSITION] nvarchar(3) NULL
, [TEAM] nvarchar(3) NOT NULL
, [INJURY] nvarchar(20) NULL
, [PRACTICESTATUS] nvarchar(40) NULL
, [GAMESTATUS] nvarchar(20) NULL
);
GO
ALTER TABLE [INJURIES] ADD CONSTRAINT [PK_INJURIES] PRIMARY KEY ([WEEK],[NAME],[SURNAME],[TEAM]);
GO
